Complete Analysis

The Complete Analysis option runs system integrity checks on all the key data files to confirm that the summary total stored in one file equals the sum of the detail transactions used to calculate the summary balance. If any problems are encountered, a detail report is printed which is used by the Net•Yield technician to correct the discrepancy. The user can print or e-mail the Net•Yield Support Department directly if a system integrity is found.

The data integrity check can be run as part of the Close End of Day (EOD) process or run manually from the menu. It is recommended that the check data integrity be run as part of the EOD process and any reports generated be printed from the Print End of Day option and sent to the Net•Yield Support Department immediately. The integrity reports will also be emailed directly to the Net•Yield Support Department when generated during the Close End of day process

• Customer Balances – Confirms that the summary beginning and ending open balances for each customer equals the total unpaid invoices, receivables adjustments, and unapplied payments. It also confirms that the unpaid balance on each invoice equals the invoice amount less payments applied.
• Vendor Balances – Confirms that summary beginning and ending balance for each vendor equals the unpaid balance of vouchers and voucher adjustments. It also confirms that the unpaid voucher and voucher adjustment balance equals the voucher amount less checks applied
• Inventory Balances – Confirms that the current on-hand balance for an item equals the total balance for the lot less uncosted items
• Lotted Integrity Checking – Confirms that the summary balance for a lot equals the lot balance less uncosted transactions and that the on-hand balance equals the amount inducted into the lot less releases and commitments
• Committed Integrity Checking - Confirms that the total slot balances equals the total lot balance, the total reserved and committed balance for a lot equals the total sales order, planned transfer and work order committed and reserved balance, the total slot reserved and committed balance equals the total sales order, planned transfer and work order committed and reserved balance and lot reserve and committed balances
• Trial Balance - Summary – Confirms that the trial balance summary equals the detail of the posted transactions
• A/P & A/R to Trial Balance – Confirms that the account payable and account receivable sub-ledgers equal the ledger account balance
• Accounting Model Proved – Confirms that debits equal credits for the current and prior periods
• Posted Transactions – Confirms that debits equal credits of all ledger batches are in balance
• Duplicate Inv/Ord Check – Checks for duplicate sales order and invoice numbers. The system will confirm that there are no duplicate invoice numbers for the last 10,000 invoices issued.
• Hold Lot Check – Confirms that all transactions on hold equal the hold balance for the item and lot
• Cust/Vend/Item Integrity – Checks for duplicate customer, item and vendor IDs
• Duplicate Voucher Check – Checks for duplicate purchase order and voucher reference numbers.
• Unposted Batch Check - Confirms that all Unposted Accounting batches are in balance.
• Cost of Goods - Confirms that all Cost of Goods Sold batches are in balance.

Security Required : System - System Administration